library(ezknitr)
library(readr)
There are a few things that come to mind when anyone thinks about Vancouver. They might think about nature, mountains, the ocean, and of course, the insane cost of housing. High housing prices and in turn, land value, have become apart of Vancouver's identity; it is for this reason that I am interested in analyzing external effects on land value. One of the possibly more overlooked factors is the correlation of land value and public trees. In this analysis, I will see if there is any significance between land value and trees owned, planted, and maintained by the City of Vancouver.
##Analysis Using the property tax report for land values provided by the City of Vancouver, as well as the dataset for street trees in Vancouver, this analysis will test the correlation between land value and various attributes of street trees. These attributes include the size, age, number, and location of the trees.
Figure 1: Mean Land Value by Neighbourhood:
The map shown above displays the Mean Land Value by Neighbourhood in the City of Vancouver. You can see that the darker areas represent lower land values, while the lighter areas represent areas of higher land value. These shaded areas are generated by taking the average land value per neighbourhood. We can see that land values generally higher in west Vancouver than they are in East Vancouver.
Figure 2: Mean Tree Diameter by Neighbourhood:
Similarly, we can see that there is a definite corrlation between mean land value and the mean trunk diameter by neighbourhood, as shown in the figure above. The high land value as seen in figure 1 correlates directly to the large tree trunk diameters shown in figure 2 by neighbourhood, respectively.
Figure 3: Number of Trees Planted by Neighbourhood since 2015:
The map shown above displays the number of trees planted in Vancouver by neighbourhood since 2015. In contrast to Figure 1: Mean Land Value By Neighbourhood, we can see that there have been many trees planted in East Vancouver and the Dunbar neighbourhood since 2015.
Figure 4: Change in Land Value by Neighbourhood between 2015 and 2016:
The above map displays the mean change in land value between 2015 and 2016. The lighter areas represent the greatest positive change, while the darker areas represent the smallest change. We can see that the greatest increase in land value has been in East Vancouver. It seems as though there might be some correlation between the change in land value (Figure 4) and the number of trees planted (Figure 3).
Figure 5: Linear Model of Change in Land Value by Trees Planted per Neighbourhood:
Above is a linear model of the change in mean land value by neighbourhood with respect to the number of trees planted since 2015. The slope of this model would seem to indicate that there is infact no correlation between the number of trees planted since 2015 and the mean change in land value from 2015 to 2016.
Figure 6: Linear Model of Mean Land Value by Trees Planted per Neighbourhood:
The linear model above displays the correlation between mean land value and trees planted since 2015 by neighbourhood. We can see that there is infact a negative relationship between these attributes. This is perhaps as expected, as there is a push to plant more trees in the less established neighbourhoods.
As the analysis above has shown, there is some correlation between land value and the size and number of trees by neighbourhood, however it is not enough to conclude that the existence of trees in souly responsible for the increase or decrease in the land value.